Create VIEW [dbo].[vSpecificDonations]
   AS
    SELECT    
            MAX(TransactionDate)as Date,  
            MAX(ID) as ID,  
            MAX(OriginalTransaction) as OriginalTransaction,  
            MAX(GiftType) as GiftType,  
            MAX(Amount) as Amount,  
            MAX(SourceSystem) as SourceSystem,
            MAX(SolicitorID) as SolicitorID,  
            MAX(IsMatchingGift)    as IsMatchingGift,  
            MAX(RequestNumber) as RequestCode,  
            MAX(Fund) as Fund,  
            MAX(Appeal) as Appeal ,
            MAX(Campaign) as Campaign  
                FROM vDonationsDetail
                    GROUP BY OriginalTransaction

GO
GRANT REFERENCES ON  [dbo].[vSpecificDonations] TO [IMIS]
GRANT SELECT ON  [dbo].[vSpecificDonations] TO [IMIS]
GRANT INSERT ON  [dbo].[vSpecificDonations] TO [IMIS]
GRANT DELETE ON  [dbo].[vSpecificDonations] TO [IMIS]
GRANT UPDATE ON  [dbo].[vSpecificDonations] TO [IMIS]
GO